package com.springdoor.goods.mapper;

import java.util.List;
import java.util.Map;

import com.alibaba.fastjson2.JSONObject;
import com.springdoor.goods.domain.SprdGoodsShop;

/**
 * 店铺商品关联Mapper接口
 *
 * @author llshs
 * @date 2024-12-04
 */
public interface SprdGoodsShopMapper {

    /**
     * 查询店铺商品关联
     *
     * @param gshopId 店铺商品关联主键
     * @return 店铺商品关联
     */
    public SprdGoodsShop selectSprdGoodsShopByGshopId(Long gshopId);

    /**
     * 查询店铺商品关联列表
     *
     * @param sprdGoodsShop 店铺商品关联
     * @return 店铺商品关联集合
     */
    public List<SprdGoodsShop> selectSprdGoodsShopList(SprdGoodsShop sprdGoodsShop);

    /**
     * 新增店铺商品关联
     *
     * @param sprdGoodsShop 店铺商品关联
     * @return 结果
     */
    public int insertSprdGoodsShop(SprdGoodsShop sprdGoodsShop);

    /**
     * 修改店铺商品关联
     *
     * @param sprdGoodsShop 店铺商品关联
     * @return 结果
     */
    public int updateSprdGoodsShop(SprdGoodsShop sprdGoodsShop);

    /**
     * 删除店铺商品关联
     *
     * @param gshopId 店铺商品关联主键
     * @return 结果
     */
    public int deleteSprdGoodsShopByGshopId(Long gshopId);

    /**
     * 批量删除店铺商品关联
     *
     * @param gshopIds 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteSprdGoodsShopByGshopIds(Long[] gshopIds);

    public Integer findMaxOrderNum(Long deptId);

    public List<Map<String, Object>> selectShopGoodsTypeNum(SprdGoodsShop sprdGoodsShop);

    public int putOnShops(Map<String, Object> map);

    public SprdGoodsShop selectGoodsMainByDeptGnumber(SprdGoodsShop sprdGoodsShop);
}
